package en.edu.cuit.aumalls.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import cn.edu.cuit.aumalls.entity.GoodsType;


public interface GoodsTypeMapper {
	
	@Select("select * from goods_type where type_lv = 1")
	List<GoodsType> findlv1();
	
	@Select("select * from goods_type")
	List<GoodsType> findAll();
	
	@Select("select type_id from goods_type where type_name Like #{typeName}")
	int findTypeID(@Param("typeName")String typeName);
}
